UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ooUd4dupGQJD4QZzPYU1N1GHwIXIWtwPS3o1GkcIwWE=' 
WHERE 
  key_id = '14328ab7901aae9a61e65cf6b2bfbe630bf0bd0e2e5ede584aa93be3abf34854' 
  AND (
    token = 'ooUd4dupGQJD4QZzPYU1N1GHwIXIWtwPS3o1GkcIwWE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037