UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'jxzIthGY97fXsnN4qokmNGW5D83PZWwmQhR1yk5yG9k=' 
WHERE 
  key_id = '89dc8f20a6bb6acb989ce5e25ecb7c6c36f90b14ecf12b32b590b8e12a80bc0a' 
  AND (
    token = 'jxzIthGY97fXsnN4qokmNGW5D83PZWwmQhR1yk5yG9k=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00039