UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BJ1lwgGdGSqpUqjbJQXB9OYh6GVvRg74J7lYeWlISrg='
WHERE
key_id = 'a8ad620dcaaa22917f1ab0c76b6977d96384a5c277b4ff7034f2b01d54874d92'
AND (
token = 'BJ1lwgGdGSqpUqjbJQXB9OYh6GVvRg74J7lYeWlISrg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)