UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'mRfyz84Dc/XyiB2+p+Qq9Ho6YMWJRD7hVopdSkPYupU=' 
WHERE 
  key_id = '1bba500b0d3806b24b9261663c7d318a62dcb091f4e307a111a95d377ee26ec7' 
  AND (
    token = 'mRfyz84Dc/XyiB2+p+Qq9Ho6YMWJRD7hVopdSkPYupU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020