UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hKjWuYWqMrZLZ1JaZDrqL/UQNILpg9Nt3L5XaMX5cT8='
WHERE
key_id = '6f0b3bf9a41202fa5f6978770af4ad140c5795f13ec5040be7b97d62fc1ca449'
AND (
token = 'hKjWuYWqMrZLZ1JaZDrqL/UQNILpg9Nt3L5XaMX5cT8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)