UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P8Q5fwLAsZTz6xonS8xSOq9surtfFGuwIrSU3PRBRz0='
WHERE
key_id = 'f7ffa21a2f987ac2f4fcde20c053e60c2536a74f32138ca72acbe575b1478600'
AND (
token = 'P8Q5fwLAsZTz6xonS8xSOq9surtfFGuwIrSU3PRBRz0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)