UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qX2ZvQ3bI35SIMBqf/z9UKz61BHABzhGBHERynwQfAI='
WHERE
key_id = 'd139f1a9f6cfdff2b29d9f246f31357afb2e09d3f4bc6ae11bf446730cba4bf3'
AND (
token = 'qX2ZvQ3bI35SIMBqf/z9UKz61BHABzhGBHERynwQfAI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)