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