UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8X4/bwVvgEA1EaYJ45Jjp8hTuOac8ihTSCXlV/tfUIU='
WHERE
key_id = '94eaa13b4519ba3f88fee6b174a88f57288e50871a28efb86e8fcd374b075df8'
AND (
token = '8X4/bwVvgEA1EaYJ45Jjp8hTuOac8ihTSCXlV/tfUIU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)