UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fchGoTGT4o5IhETyFMA6TyvdUDu5IqUYILiIFw3i71A='
WHERE
key_id = '0d28db17846c51ee43695a153b6bbdc52c84536ce7786d37b8ae3399efff1766'
AND (
token = 'fchGoTGT4o5IhETyFMA6TyvdUDu5IqUYILiIFw3i71A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)