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