UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Xx8U20zTO4qsRLP+kqDFBjjHssIOR7YlB5L9dA47Z4E=' 
WHERE 
  key_id = '536ff79361474e22714ff646930d2204528f4966b48e818713904abb172ad123' 
  AND (
    token = 'Xx8U20zTO4qsRLP+kqDFBjjHssIOR7YlB5L9dA47Z4E=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035