UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Sdo0x0VglT+Z388YgBsxl4H87HSpOPMpKGHzC/3/LMg='
WHERE
key_id = 'ae003f7a6f8658e4d7bd637c44be142d84362e0ef3e9caae17927179c3378d3d'
AND (
token = 'Sdo0x0VglT+Z388YgBsxl4H87HSpOPMpKGHzC/3/LMg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)