UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rBPxozpY2tMCXWFuIKRNe4NzsMlIZBDOi7z08y+ms38='
WHERE
key_id = '4710824dd54bb19f7a99761b76d5b7cf017719237361e24a62c3272b2d907ffb'
AND (
token = 'rBPxozpY2tMCXWFuIKRNe4NzsMlIZBDOi7z08y+ms38='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)