UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'McYF1XBb3XiXCNHgTSyEV/3eS0l0vrrIUYo1+JSmUAA=' 
WHERE 
  key_id = '3f3786efabc9bda7ea4e194d9c15de2263ad9212c325d7a66877b54f3fb6c002' 
  AND (
    token = 'McYF1XBb3XiXCNHgTSyEV/3eS0l0vrrIUYo1+JSmUAA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031