UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BBEC5bjH6ljBtLyWA+ycmbV61eY0EOmgjv288qZKymk='
WHERE
key_id = 'f37935cc748a72cd2156dc6e8c1219e22082003b32b64dfea9476d54f853a5d0'
AND (
token = 'BBEC5bjH6ljBtLyWA+ycmbV61eY0EOmgjv288qZKymk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)