UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+JqeMOeRizY/nftiaBO1bI1irF1TDuouldmhD73E/eM=' 
WHERE 
  key_id = '4f1f4e6ce6c4c59e573e78959cd3d266896d1477e5426473a9e0244ad8665940' 
  AND (
    token = '+JqeMOeRizY/nftiaBO1bI1irF1TDuouldmhD73E/eM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028