UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0at5cgISLpXIabRCaXYf5b8hsv9Ea6UvMSnRLbkDc3Y='
WHERE
key_id = '8ab8392f160ddb7ed08ad18fbe559092b3ffa3ce88cfdcf28a4e64ba164ea7a7'
AND (
token = '0at5cgISLpXIabRCaXYf5b8hsv9Ea6UvMSnRLbkDc3Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)