UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Rv63rBQ/0CQSMzPQ0C38pQ7YgoXEPOkB7D7ft6wACm4=' 
WHERE 
  key_id = 'fb213f42168d17a9877d43bf7b8a9b21d53307a99443081c1169f9524651c92f' 
  AND (
    token = 'Rv63rBQ/0CQSMzPQ0C38pQ7YgoXEPOkB7D7ft6wACm4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032