UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'LSlms3T22uiKKz+3PWhZF34hJYy5nCxvbSfsAEbeuSk=' 
WHERE 
  key_id = '90d3dea397b53ce87e30008ade1d2d06f0c6c0d888fd8b67dd74bed73846c2fd' 
  AND (
    token = 'LSlms3T22uiKKz+3PWhZF34hJYy5nCxvbSfsAEbeuSk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035