UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aK8P6edbLdaU7lvo5iAvQOccRks40+h9g/366yNeR/g='
WHERE
key_id = 'f93fc7ba677e821d140850691d40b3ec726ccc47bfb4669905986a1dd196a8e1'
AND (
token = 'aK8P6edbLdaU7lvo5iAvQOccRks40+h9g/366yNeR/g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)