UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'kwXy2IM1yXLWxaWtXIpsU6Ne4wQ5O0419S6QXWw9SMw=' 
WHERE 
  key_id = 'fb9935ec0b2e5655e38741138ca6c828e964b8a8002f263fee7ee58df2e82276' 
  AND (
    token = 'kwXy2IM1yXLWxaWtXIpsU6Ne4wQ5O0419S6QXWw9SMw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043