UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LiBYHk8hg4OJQCcAWw7BrKxLmRq7o55fCCWCh1R20hI='
WHERE
key_id = '7f5fba044d1704e7eab5982a77291e378fce8acdac934eb08202cc62ab50db67'
AND (
token = 'LiBYHk8hg4OJQCcAWw7BrKxLmRq7o55fCCWCh1R20hI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)