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