UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CORcpONGg0aT9yHBGPsauHez0VGfaUVknGUs+bmYc68='
WHERE
key_id = 'c5eb34f0eaa0c40e30128ca81d2edbcf05b0ca7af3d0f03034230f2dadd28bdd'
AND (
token = 'CORcpONGg0aT9yHBGPsauHez0VGfaUVknGUs+bmYc68='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)