UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pRgW9LkM6DoPLdARcpJCNFu7kRuesHB8DVo11yQiT1w='
WHERE
key_id = '3cf49d34565be7f96ca6d1c4b5b211630fc2fe1814b46d98ab3dbc05ef431f34'
AND (
token = 'pRgW9LkM6DoPLdARcpJCNFu7kRuesHB8DVo11yQiT1w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)