UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0SQRCLHSLGiIE6j8Yi1tFq12OVmpjPU3vQYCto51iL4='
WHERE
key_id = '80468bc5e48d3cf982329e871aafa3d880417ccd2e2a0972134662aa41566c5a'
AND (
token = '0SQRCLHSLGiIE6j8Yi1tFq12OVmpjPU3vQYCto51iL4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)