UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Q9dwbiuE5FTJ9k8G0yQ35pOuMxo9PJjgVYqoUYG4sKQ=' 
WHERE 
  key_id = 'd1b5ab70a3e8247c144ef9d183481836a1ecf35dd02977b3d4d7c2aa5ffadc3e' 
  AND (
    token = 'Q9dwbiuE5FTJ9k8G0yQ35pOuMxo9PJjgVYqoUYG4sKQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029