UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9SRMrKx8llXU9UoL6SFyrSy63UO4ihRcLX4GDdx6REs='
WHERE
key_id = 'a53e35e58d367b4b95e8b886ef2359db74353368da8707345d83d2a9edb4f9f1'
AND (
token = '9SRMrKx8llXU9UoL6SFyrSy63UO4ihRcLX4GDdx6REs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)