UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VLOTiYNG84ZDzRPywmf/xT07Vt/jkFG3k1LIoIMTkU0='
WHERE
key_id = '38a091e64faae282bef0ba72a0cdde5a0e3a96a3efa252018ec88fdf729a6d97'
AND (
token = 'VLOTiYNG84ZDzRPywmf/xT07Vt/jkFG3k1LIoIMTkU0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)