UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+nxDHIvA/E+isrLjDACwvvp9/UESERMRenqbdy+mLVU=' 
WHERE 
  key_id = '2a9fbcc2d41bcc8f76ed4858950110dd1ab3a305a1c5ed0422046c160d2cbdf3' 
  AND (
    token = '+nxDHIvA/E+isrLjDACwvvp9/UESERMRenqbdy+mLVU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044