UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'NcQ7Ug4tr8agS1NeOHn7Af0yiP5Xne0g7tGEWlwr0/4=' 
WHERE 
  key_id = 'a5befcb41fc1ac0ffb9cd73d63f1fa69bbf600e8f2eada3f49da6ac547f61559' 
  AND (
    token = 'NcQ7Ug4tr8agS1NeOHn7Af0yiP5Xne0g7tGEWlwr0/4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00063