UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kxYWj3Wk3vAa8OWkukWVShpWPTEL8mmVHKrS4B1tszQ='
WHERE
key_id = '48c2e957df9832ab01f0aade535704aee96ba86e438657962497c6bb82b5a97a'
AND (
token = 'kxYWj3Wk3vAa8OWkukWVShpWPTEL8mmVHKrS4B1tszQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)