UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vsfA7JzleF0fwAcEnV2YYaV9/pee4D0Y4ogEdjwuTlo='
WHERE
key_id = '5d9e97c64b55fb951d3affed61c6136d0456b557bf4094cde5670e5001fe5227'
AND (
token = 'vsfA7JzleF0fwAcEnV2YYaV9/pee4D0Y4ogEdjwuTlo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)