UPDATE 
  cscart_june_setuplock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'UcG7XXlXzSjTJsbAIrH3dlCAB1tqyoBeu7y/g/xrylg=' 
WHERE 
  key_id = 'efd570d59596ab00a9acbafc57d7e347b1164fb78ac0ad74430538ad8a8c9291' 
  AND (
    token = 'UcG7XXlXzSjTJsbAIrH3dlCAB1tqyoBeu7y/g/xrylg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037