UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xVC+OJwfxE0P59683J5cbk4v0y9MiIQSapr9AkZjTXE=' 
WHERE 
  key_id = '4fe5b8e20d8ad44ae913a645e2d1d5f11fcb189aedc26a2be4c0e3777fa309ef' 
  AND (
    token = 'xVC+OJwfxE0P59683J5cbk4v0y9MiIQSapr9AkZjTXE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034