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