UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'zmslf3n5bYIzKfWEiU9G15SH+yQUdnLRGJyYeE2Zrak=' 
WHERE 
  key_id = '8a9397ad7ac159ca2e1fe392584a53021d25530f3b94decb65137a8aa4f86455' 
  AND (
    token = 'zmslf3n5bYIzKfWEiU9G15SH+yQUdnLRGJyYeE2Zrak=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047