UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'WZ4N5D7Ui38hbs8xvmTWco+MIvA8isJhNsH2z7anbaQ=' 
WHERE 
  key_id = 'ceb4293b9803490ab29591a28bf037da949c741c302baaa4add65328292c9f7d' 
  AND (
    token = 'WZ4N5D7Ui38hbs8xvmTWco+MIvA8isJhNsH2z7anbaQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00014