UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SggfbsX/iU/PI4rf1NFDUC2Ts3wm4t7fQIwgsh2ym5o='
WHERE
key_id = '05d47d8dcc03ea795ea6392b7c200f624533f3ccc3a7e688c4f7ad29eede0ba0'
AND (
token = 'SggfbsX/iU/PI4rf1NFDUC2Ts3wm4t7fQIwgsh2ym5o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)